2014-07-29 - 13767 - Enhancement - Intercompany customers #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
13767 - Intercompany customers
Purpose
Need to restrict intercompany customers 1015951, 1015928 from all BEx and Voyager Queries.
Admin Info
Purpose
|
To restrict 1015951, 1015928 customers from all BEx and Voyager Queries.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
07/29/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
0CUSTOMER, 0SOLD_TO
|
Document Status
|
Complete
|
Estimates
SLNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
05
|
3
|
Development/ Config
|
08
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Transports
|
01
|
|
TOTAL
|
16
|
References
Prior Tickets
None
Documents
Attached with related release note.
Functional Requirement
Purpose/WHY:
Need to restrict 1015951, 1015928 customers from all BEx and Voyager Queries where customers are already being restricted.
In Scope:
Append 1015951, 1015928 customers to the existing intercompany list.
Out of Scope:
None
Solution Summary
1. Need to create open transport request in BPD.
2. Need to exclude 1015951, 1015928 customers for 0SOLD_TO (or) 0CUSTOMER infoobject in filter section of BEx queries.
3. Need to collect all the queries belonging to voyager into a single transport request & remaining all the BEx Queries into another transport request.
4. Transport it to BPQ for testing and move it to BPP after successful testing.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check whether the changes are collected into the transport request.
|
All the changes should be collected into the transport request.
|
2
|
Check if all the Intercompany Customers(44) are excluded in the BEx query.
|
All Intercompany customers(44) should be excluded in BEx queries.
|
3
|
Check if in the following BEx Queries ZCOPA_C03_Q017, ZCOPA_C03_Q018 and VMP_OPASA_Q003 Intercompany Customers(44) are Included.
|
Intercompany Customers(44) should be Included for these BEx Queries.
|
Solution Details
1. Need to create a open transport request in BPD(BW 7.3 Development).
2. Need to exclude 1015951, 1015928 customers for 0SOLD_TO (or) 0CUSTOMER infoobject in filter section of BEx queries.
3. Need to collect all the queries belonging to voyager into a single transport request & remaining all the BEx Queries into another transport request.
4. Transport it to BPQ(BW 7.3 Quality) for testing and move it to BPP(BW 7.3 Production) after successful testing.
Issues
None